dataSource {
	pooled = true
	driverClassName = "net.sourceforge.jtds.jdbc.Driver"
	dbCreate = "validate"
}
hibernate {
    cache.use_second_level_cache = true
    cache.use_query_cache = false
    cache.region.factory_class = 'net.sf.ehcache.hibernate.EhCacheRegionFactory'
}
// environment specific settings
environments {
   development {
//        dataSource { 
//	        url = "jdbc:jtds:sqlserver://10.1.231.16:1433/PubsDB"
//		    username = "deautos"
//		    password = "IACFB5W5"
//			properties {
//				maxActive = -1
//				minEvictableIdleTimeMillis=1800000
//				timeBetweenEvictionRunsMillis=1800000
//				numTestsPerEvictionRun=3
//				testOnBorrow=true
//				testWhileIdle=true
//				testOnReturn=true
//				validationQuery="SELECT 1;"
//			 }
//        }
	   dataSource {
		   url = "jdbc:jtds:sqlserver://10.1.231.19:1433/PubsDB"
		   username = "deautostest"
		   password = "QW12ER34"
		   properties {
			  maxActive = -1
			  minEvictableIdleTimeMillis=1800000
			  timeBetweenEvictionRunsMillis=1800000
			  numTestsPerEvictionRun=3
			  testOnBorrow=true
			  testWhileIdle=true
			  testOnReturn=true
			  validationQuery="SELECT 1;"
		   }
	   }
	}
    test {
         dataSource {
			url = "jdbc:jtds:sqlserver://10.1.231.19:1433/PubsDB"
			username = "deautostest"
			password = "QW12ER34"
			properties {
			   maxActive = -1
			   minEvictableIdleTimeMillis=1800000
			   timeBetweenEvictionRunsMillis=1800000
			   numTestsPerEvictionRun=3
			   testOnBorrow=true
			   testWhileIdle=true
			   testOnReturn=true
			   validationQuery="SELECT 1;"
			}
		}
    }
    production {
        dataSource {
            dbCreate = "update"
            url = "jdbc:h2:prodDb;MVCC=TRUE;LOCK_TIMEOUT=10000"
            pooled = true
            properties {
               maxActive = -1
               minEvictableIdleTimeMillis=1800000
               timeBetweenEvictionRunsMillis=1800000
               numTestsPerEvictionRun=3
               testOnBorrow=true
               testWhileIdle=true
               testOnReturn=true
               validationQuery="SELECT 1"
            }
        }
    }
}
